//jump_id°ªÀÌ Á¸ÀçÇϸé id¸¦ jump_id·Î ġȯ
if($jump_id) {$id=$jump_id; $name=$jump_name;}
//±×¸®µ¥ÀÌ¼Ç Ãʱ⺯¼ö
$my_color=0xFFFFFF;
//ÇÔ¼ö µî·Ï ºÎ ========================================================
function echo_line($no, $row) {
global $d_main, $d_dep, $code, $main_no, $dep_no, $my_color, $icon, $a_border, $al_color, $ag_color,$scroll_color,$a_cut, $write_key, $read_key, $id, $atb_color,
$check_box, $thread, $down_no, $no_no, $writer_no, $date_no, $view_no, $admin_email, $opinion_num, $new_list, $vote_no, $cafe_url,$board,$a_bordersize,$keyword, $ftype;
//¸ñ·Ï±ÛÀÇ ±æÀÌ ÀÚ¸£±â.
//include("../../inc_file/list/cut.php");
//°Ë»ö¾î¿¡ ¹ÙÅÁ»ö ÀÔÈ÷±â
if(strlen($keyword)>0 and $ftype==subj) $email = eregi_replace("($keyword)", "$keyword", $row[email]);
else $email=$row[email];
if(strlen($keyword)>0 and $ftype==cont) $title = eregi_replace("($keyword)", "$keyword", $row[title]);
else $title=$row[title];
if(strlen($keyword)>0 and $ftype==name) $homeurl = eregi_replace("($keyword)", "$keyword", $row[homeurl]);
else $homeurl=$row[homeurl];
//À§ÀÇ ¸ñ·Ï±Û ÀÚ¸£±â¸¦ ÁÖ¼®Ã³¸®ÇÏ°í ´ëȸ¸é ´Þ¸°Àå¼Ò¿¡ ´ëȸ¸íÀÌ, ¾Æ´Ï¸é ´Þ¸°Àå¼Ò°¡ Ãâ·Â
if($row[reply_sel]==n and $row[read_only]==g and isset($row[homeurl])) $title="$homeurl";
elseif($row[reply_sel]==n and $row[read_only]==b and isset($row[homeurl])) $title="$homeurl";
elseif($row[reply_sel]==n and $row[read_only]==c and isset($row[homeurl])) $title="$homeurl";
elseif($row[reply_sel]==n and $row[read_only]==d and isset($row[homeurl])) $title="$homeurl";
elseif($row[reply_sel]==n and $row[read_only]==e and isset($row[homeurl])) $title="$homeurl";
elseif($row[reply_sel]==n and $row[read_only]==f and isset($row[homeurl])) $title="$homeurl";
else $title=$title;
//¸ñ·Ï±Û¿¡ ¾²·¹µå À̹ÌÁö ³Ö°í ¸µÅ©°É±â
include("../../inc_file/list/titlelink.php");
//Àǰߴޱ⠰³¼ö ±¸Çϱâ
include("../../inc_file/list/opinion.php");
if($row[read_only]==d and $row[reply_sel]==n and $row[sub1]<=2) $sub_3="";
//±×¸®µ¥ÀÌ¼Ç ±¸ÇöºÎ ½ÃÀÛ
if($ag_color=="0x000000") $my_color=$atb_color;
else {$my_color=$my_color; $my_color=dechex($my_color-$ag_color);}
echo "\n";
//üũ¹Ú½º¸¦ »ç¿ëÇÒ °ÍÀΰ¡ ¸» °ÍÀΰ¡ °áÁ¤
if($check_box==a)
echo " \n";
//±×¶óµ¥ÀÌ¼Ç ±¸ÇöºÎ ³¡
$my_color=hexdec($my_color);
return ($file_type);
}
// ========================================================ÇÔ¼ö µî·Ï ºÎ
//db·ÎºÎÅÍ µ¥ÀÌŸ¸¦ ºÒ·¯¿Í¼ °¡°øÃ³¸®
//³ªÁß Àüü³»¿ë º¸±â¸¦ ÇϱâÀ§ÇØ º¯¼ö·Î ó¸®ÇÑ ºÎºÐ
if($id) $id_ex = "and id='$id'";
//ÈÆ·Ã³»¿ë°ú ´ëȸ³»¿ëÀ» ºÐ·ùÇØ¼ Ãâ·ÂÇϱâÀ§ÇÑ Á¶°Ç¹®
if($reply_sel==y) $repl_ex="and reply_sel='y'"; elseif($reply_sel==n) {$repl_ex="and reply_sel='n'"; $arr="read_only,";}
//°Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â
if(strlen($keyword) > 0)
{
switch ($ftype) {
case "subj":
$colm = email;
break;
case "cont":
$colm = title;
break;
case "name":
$colm = homeurl;
break;
}
$sql="select * from $board
where code = '$code' and main_no>0 and
add_no =0 $id_ex and
$colm like '%$keyword%'
order by email desc, main_no desc, dep_no desc";
}
else
$sql= "select * from $board
where code = '$code' and add_no=0 and main_no>0 $id_ex $repl_ex
order by $arr email desc, main_no desc, dep_no desc";
//¾Æ·¡ sql¹®Àº °øÁö±ÛÀ» ¼±Åà Ãâ·ÂÇϱâ À§ÇØ ÀÛ¼ºÇÑ °ÍÀÌ´Ù.
$sql_notice= "select * from $board
where code = '$code' and add_no=0 and main_no<0 $id_ex $repl_ex
order by main_no desc, dep_no desc";
$result_notice = mysql_query($sql_notice);
$result = mysql_query($sql);
//$colm ="";
//ÇÑȸ鿡 Ãâ·ÂÇÒ ÁÙ ¼ö
$rows = $a_rows;
//ÇÑ È¸é¿¡ Ãâ·ÂÇÒ ÆäÀÌÁö ¼ö
$page_scale = $a_page;
// Àüü±Û ¸ñ·Ï ¼ö
$count = mysql_num_rows($result);
//=======7ÀÏ,30ÀÏ,Àüü, Á¾¸ñº°´Þ¸®±âÀÇ ÃÑ´Þ¸°°Å¸®¿Í ´Þ¸°½Ã°£ µîÀ» »Ì±âÀ§ÇÑ ÇÔ¼ö======
function reco($check_date,$read_only) {
global $code, $id, $board, $id_ex, $repl_ex, $colm, $keyword;
if($check_date==100000) {
$sql="select * from $board
where code = '$code' and main_no>0 and
add_no =0 $id_ex and
$colm like '%$keyword%'
order by email desc, main_no desc, dep_no desc";
}
else {
if($read_only==h) $read_on=""; //read_only=hÀ̸é ÈÆ·Ã³»¿ë¸¸
else $read_on="and read_only='$read_only'"; //read_only°¡ ±×¿Ü °ªÀ» °¡Áö¸é °ª¿¡ µû¶ó Äõ¸®
$sql= "select * from $board
where code = '$code' and add_no=0 and main_no>0 $id_ex $repl_ex $read_on and DATE_SUB(CURDATE(),INTERVAL $check_date DAY) <= email
order by read_only, sub1 desc, sub2 desc, sub3 desc, main_no desc, dep_no desc";
}
$result = mysql_query($sql);
$line = 0;
$total_distance = 0;
$total_time = 0;
$count = mysql_num_rows($result);
while($rowr = mysql_fetch_array($result))
{
$total_distance = $total_distance+$rowr[link1];
$total_time = $total_time+$rowr[sub1]+$rowr[sub2]/60+$rowr[sub3]/3600;
if($read_only==h) $best_record="00:00:00";
else $best_record = "$rowr[sub1]:$rowr[sub2]:$rowr[sub3]"; //´ëȸ±â·Ï¿¡¼ ¸¶Áö¸· ·¹Äڵ尡 ÃÖ°í±â·Ï
if(++$line==$count) break;
}
if($rowr) {
$total_hour=floor($total_time); //¼ø¼öÇÑ Àüü½Ã°£À» ±¸ÇÑ´Ù.
$total_minute=($total_time-$total_hour)*60; //³ª¸ÓÁö ºÐÀ» ±¸ÇÑ´Ù.
$total_minute=floor($total_minute); //¼Ò¼öÁ¡ ÀÌÇÏ´Â ÀÚ¸¥´Ù.
$ave_distance=$total_distance/$total_time; //Æò±Õ¼Óµµ¸¦ ±¸ÇÑ´Ù.
$ave_distance = number_format($ave_distance,2); //¼Ò¼öÁ¡ 2ÀÚ¸®±îÁö¸¸ Ç¥Çö
$total_distance=number_format($total_distance,0); //°Å¸®¸¦ °¡°ø
mysql_data_seek($result,0); //À§ ÀÛ¾÷ÀÌ ³¡³µÀ¸¸é Æ÷ÀÎÅ͸¦ óÀ½ÀÇ À§Ä¡·Î º¸³½´Ù.
}
else {
$total_distance=0;
$total_hour=0;
$total_minute=0;
$ave_distance=0;
$best_record="00:00:00";
}
//ÇÔ¼ö°¡ ºÒ·¯Áø °÷¿¡ Ãâ·Â
echo "
\n";
//¸®½ºÆ®¸¦ ¼±Åà Ãâ·ÂÇϱâ(d_main°ú d_depÀº view.html¿¡¼ ³Ñ¾î¿Â °ª),±Û ¹øÈ£¿Í ¼±Åà À̹ÌÁö Ãâ·Â
if($no_no==a && $row[main_no]==$d_main && $row[dep_no]==$d_dep)
echo " \n";
elseif($no_no==a)
echo "$sub_3 $no \n";
//´Þ±â±âÇÑ ³¯Â¥¸¦ Ãâ·ÂÇÑ´Ù(emailº¯¼ö¿¡ ÀúÀå).
echo "$sub_3 $email \n";
//´Þ¸°Àå¼Ò¸¦ Ãâ·ÂÇÑ´Ù.(titleº¯¼ö »ç¿ë)
//if($row[homeurl]) $title="$title";
echo "$title $count_opp \n";
//´Þ¸°°Å¸®¸¦ Ãâ·ÂÇÑ´Ù.(º¯¼ö link1¸¦ »ç¿ëÇß´Ù.)
echo "$sub_3 $row[link1] km \n";
//´Þ¸°½Ã°£À» Ãâ·ÂÇÑ´Ù.(½Ã-sub1, ºÐ-sub2, ÃÊ-sub3)
echo "$sub_3 $row[sub1]:$row[sub2]:$row[sub3] \n";
//³¯¾¾¸¦ Ãâ·ÂÇÑ´Ù.(º¯¼ö link2¸¦ »ç¿ëÇß´Ù.)
echo "$sub_3 $row[link2] \n";
//ÄÁµð¼ÇÀ» Ãâ·ÂÇÑ´Ù. (º¯¼ö link3¸¦ »ç¿ëÇß´Ù.)
echo "$sub_3 $row[link3] \n";
//´ëȸ¿©ºÎ¸¦ Ãâ·ÂÇÑ´Ù.(reply_selÀÌ yÀ̸é 'ÈÆ·Ã'À», nÀ̸é '$read_only¸¦ Á¶°Ç¿¡ ¸Â°Ô Ãâ·Â
if($row[reply_sel]==n) {
if($row[read_only]==g) $game="5k";
elseif($row[read_only]==b) $game="10km";
elseif($row[read_only]==c) $game="HALF";
elseif($row[read_only]==d) $game="FULL";
elseif($row[read_only]==e) $game="¿ïÆ®¶ó";
elseif($row[read_only]==f) $game="±âŸ";
}
else $game="ÈÆ·Ã";
echo "$sub_3 $game \n";
echo "
$count
$total_distance
$total_hour ½Ã $total_minute ºÐ
$ave_distance
$best_record
color==$avt_color?>> if($id) echo "$board_title [$name]"; else echo "$board_title [Àüü]";?> | ||||||||||||||||||||||||
|
||||||||||||||||||||||||
$special_condi | \n"; echo "ÃÑ °Ô½Ã¹°: $count, ÆäÀÌÁö: $page/$total "; if($a_ccode==a) { echo "¿À´Ã: $counter->count_today, Àüü:$counter->count_total"; } echo " | \n"; echo "
|
if($check_box==a) {echo " ";} ?> |
if(isset($id) and empty($jump_id)) include("../../inc_file/list/write.php");?> |
![]() |